/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_department.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_DEPARTMENT
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_department.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "app97_global.h" 
#include "db_ppm_department.hxx"

CTable_PPM_DEPARTMENT::CTable_PPM_DEPARTMENT( )
 :NPCRecordSet( )
{
  setTableName( "PPM_DEPARTMENT" );
  prepareTable();
  prepareQuery();
 
  TYPE.setField( "TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( TYPE );
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 50, 0 );
  makeTableItem( NAME );
  AREA_ID.setField( "AREA_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( AREA_ID );
  STATE.setField( "STATE", DATA_CHAR, 10, 0 );
  makeTableItem( STATE );
  OP_STAFF.setField( "OP_STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( OP_STAFF );
  OP_TEAM_ID.setField( "OP_TEAM_ID", DATA_CHAR, 20, 0 );
  makeTableItem( OP_TEAM_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REAL_MODIFY_DATE.setField( "REAL_MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( REAL_MODIFY_DATE );
  IS_MARKET.setField( "IS_MARKET", DATA_CHAR, 6, 0 );
  makeTableItem( IS_MARKET );
}


CTable_PPM_DEPARTMENT::CTable_PPM_DEPARTMENT( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_DEPARTMENT" );
  prepareTable();
  prepareQuery();
 
  TYPE.setField( "TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( TYPE );
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 50, 0 );
  makeTableItem( NAME );
  AREA_ID.setField( "AREA_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( AREA_ID );
  STATE.setField( "STATE", DATA_CHAR, 10, 0 );
  makeTableItem( STATE );
  OP_STAFF.setField( "OP_STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( OP_STAFF );
  OP_TEAM_ID.setField( "OP_TEAM_ID", DATA_CHAR, 20, 0 );
  makeTableItem( OP_TEAM_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REAL_MODIFY_DATE.setField( "REAL_MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( REAL_MODIFY_DATE );
  IS_MARKET.setField( "IS_MARKET", DATA_CHAR, 6, 0 );
  makeTableItem( IS_MARKET );
}

CTable_PPM_DEPARTMENT::~CTable_PPM_DEPARTMENT( )
{
    close();
}

